package com.diana.mapper;

import com.baomidou.mybatisplus.plugins.Page;
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.diana.entity.ManagerRole;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 *  Mapper 接口
 * </p>
 *
 * @author anzhi
 * @since 2019-04-21
 */
public interface ManagerRoleMapper extends BaseMapper<ManagerRole> {

    @Select("SELECT * FROM manager_role a where 1=1 ${joinsql} and a.status !=2 ")
    List<Map<String,Object>> getRoleList(@Param("joinsql") String joinsql, Page<Map<String, Object>> page);

}
